
/****** Object:  StoredProcedure [dbo].[SFDA_authority_reportsToUp]    Script Date: 07/27/2013 18:22:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[SFDA_authority_reportsToUp]
@staffId int
as
set nocount on
update t_treestaff set idResportTo = 0 where staffId = @staffId
select 1
GO

